RootZanli & NinjaCr3

: / home / o5t6x7pgljbm / public_html / admin / app /
Filename : CollegeController.php
back
<?php

namespace App\Http\Controllers\Admin;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Models\College;
use App\Models\Country;
use App\Models\CollegeImage;
use App\Models\Goal;
use App\Models\Course;
use App\Models\CollegeCourse;
use App\Models\CollegeGoalWeightage;
use App\Models\PopularMajor;
use Auth;
use Hash;
use Session;
use DB;
use Socialite;
use Image;
Use Response;
use Helpers;
use File;

class CollegeController extends Controller
{
    public function index()
    {
        $colleges = College::get();
        $countries = Country::get();
        return view('Admin.College.index',compact('colleges','countries'));
    }

    public function college_list(Request $request)
    {
        $columns = array("college_name","college_image","tuition_fee","application_deadline","country_name","ivy_league_badge","is_featured","college_id");
        $columns2 =array("colleges.college_name","colleges.college_image","colleges.tuition_fee","colleges.application_deadline","countries.country_name","colleges.ivy_league_badge","colleges.is_featured","colleges.college_id");

        $totalData = College::count();
        $limit = $request->input('length');
        $start = $request->input('start');

        $dir   = $request->input('order.0.dir');

        $query = College::select($columns2)->join('countries','countries.country_id','=','colleges.country_id');

        if (!empty($request->input('search.value'))) {
            $search = $request->input('search.value');
            $query->where(function ($query2) use ($columns2, $search) {
                foreach ($columns2 as $key => $value) {
                    if ($key == 0) {
                        $query2->where($value, 'LIKE', "%{$search}%");
                    } else {
                       $query2->orWhere($value, 'LIKE', "%{$search}%");
                    }
                }
                return $query2;
            });
        }

        $country_id = $request->country_id;
        $ivy_league_badge = $request->ivy_league_badge;

        if (!empty($country_id)) {
            $query->where('countries.country_id', $country_id);
        }

        if (!empty($ivy_league_badge)) {
            $query->where('colleges.ivy_league_badge', $ivy_league_badge);
        }

        if (!empty($country_id) && !empty($ivy_league_badge)) {
            $query->where('countries.country_id', $country_id)
                  ->where('colleges.ivy_league_badge', $ivy_league_badge);
        }

        $colleges = $query->get();
        $totalFiltered = $colleges->count();

        $colleges = $query->offset($start);
        $colleges = $query->limit($limit);
        if(isset($columns2[$request->input('order.0.column')])){
            $order = $columns[$request->input('order.0.column')];
            $colleges = $query->orderBy($order,$dir);
        }
        if(isset($request->sort_by) && $request->sort_by == 1)
            $colleges = $query->orderBy('colleges.created_at', 'asc');
        else
            $colleges = $query->orderBy('colleges.created_at', 'desc');

        $colleges = $query->get();

        //$totalFiltered = $query->count();

        $data = array();
        if(!empty($colleges)) {
            foreach ($colleges as $key => $college) {
                $edit   = route('colleges.edit',$college->college_id);
                $delete = route('colleges.destroy', $college->college_id);

                foreach ($columns as $key => $column) {

                    if ($column == 'college_id') {
                        $nestedData[$column] = "<form action='{$delete}' method='POST'
                                                    id='collegeTable-".$college->$column."'>
                                                    <input name='_method' type='hidden' value='DELETE'>
                                                    <a href='{$edit}' title='EDIT' class='mb-6 btn-floating waves-effect waves-light gradient-45deg-green-teal gradient-shadow'>
                                                    ".csrf_field()."
                                                    <i class='material-icons'>edit</i></a>
                                                    <button type='button' title='DELETE' class='mb-6 btn-floating waves-effect waves-light gradient-45deg-purple-deep-orange gradient-shadow' onclick='delete_college(".$college->$column.");'>
                                                        <i class='material-icons'>clear</i>
                                                    </button>
                                                </form>";
                    }

                    else if($column == 'created_at') {
                         $nestedData[$column] = date('j M Y h:i a',strtotime($college->$column));
                    }else if($column == 'college_image') {
                        $nestedData[$column] = '<img src="'.asset($college->college_image).'" width="65px"/>';
                    }
                    else if($column == 'application_deadline') {
                        $nestedData[$column] = date('d M Y',strtotime($college->$column));
                    }
                    else if ($column == 'is_featured' && $college->is_featured == 1) {
                        $nestedData[$column] = '
                                        <div class="switch">
                                            <label>
                                                <input type="checkbox" class="chkbox" data-college-id="'.$college->college_id.'" value="'.$college->$column.'" style="border-style: solid;" checked>
                                                <span class="lever"></span>
                                            </label>
                                        </div>';
                    }
                    else if($column == 'is_featured' && $college->is_featured == 0){
                        $nestedData[$column] = '
                                    <div class="switch">
                                       <label>
                                            <input type="checkbox" class="chkbox" data-college-id="'.$college->college_id.'" value="'.$college->$column.'" style="border-style: solid;">
                                            <span class="lever"></span>
                                        </label>
                                   </div>';
                    }
                    else {
                        $nestedData[$column] = $college->$column;
                    }
                }
                $data[] = $nestedData;
            }
        }
        //echo count($data);exit;

        $json_data = array(
                    "draw"            => intval($request->input('draw')),
                    "recordsTotal"    => intval($totalData),
                    "recordsFiltered" => intval($totalFiltered),
                    "data"            => $data
                    );
        // echo '<pre>';print_r($json_data);die;
        echo json_encode($json_data);
    }

    public function is_featured(Request $request)
    {
        // dd($request->all());
        College::where('college_id', $request->college_id)->update([
          'is_featured' => $request->is_featured,
        ]);
        echo $request->is_featured;exit;
        return response()->json(['success'=>'Status change successfully.']);
    }

    public function create()
    {
        $countries = Country::get();
        $colleges = College::get();
        $courses = Course::get();
        $goals = Goal::get();
        return view('Admin.College.create',compact('countries','goals','courses'));
    }

    public function store(Request $request)
    {
        $validate = $request->validate([
            'college_name' => 'required',
            // 'collegeImage' => 'required',
            'tuition_fee' => 'required',
            'application_deadline' => 'required',
            'scholarship_points' => 'required',
            'sat_min_range' => [
                                    'nullable', // The field can be null
                                    'numeric', // Ensures the value is a number
                                    'required_with:sat_max_range', // Required if sat_max_range is present
                                ],
            'sat_max_range' => [
                                    'nullable', // The field can be null
                                    'numeric', // Ensures the value is a number
                                    'required_with:sat_min_range', // Required if sat_max_range is present
                                ],
            'act_min_range' => [
                                    'nullable', // The field can be null
                                    'numeric', // Ensures the value is a number
                                    'required_with:act_max_range', // Required if sat_max_range is present
                                ],
            'act_max_range' => [
                                    'nullable', // The field can be null
                                    'numeric', // Ensures the value is a number
                                    'required_with:act_min_range', // Required if sat_max_range is present
                                ],
            // 'high_school_gpa' => 'numeric',
            // 'median_salary' => 'numeric',
            // 'avarage_debt' => 'numeric',
            // 'graduation_rate' => 'numeric',
            // 'acceptance_rate' => 'numeric',
        ], [
            'sat_min_range.required_with' => 'The SAT Min Range is required when SAT Max Range is provided.',
            'sat_max_range.required_with' => 'The SAT Max Range is required when SAT Min Range is provided.',
            'sat_min_range.numeric' => 'The SAT Min Range must be a number.',
            'sat_max_range.numeric' => 'The SAT Max Range must be a number.',
            'act_min_range.required_with' => 'The ACT Min Range is required when ACT Max Range is provided.',
            'act_max_range.required_with' => 'The ACT Max Range is required when ACT Min Range is provided.',
            'act_min_range.numeric' => 'The ACT Min Range must be a number.',
            'act_max_range.numeric' => 'The ACT Max Range must be a number.',
        ]);

        $request['application_deadline'] = date("Y-m-d", strtotime($request['application_deadline']));

        $colleges = College::create($request->all());

        if($request->hasFile('collegeImage'))
        {
            $files = $request->file('collegeImage');

            foreach($files as $key => $file){

                $imageName = rand().time().'.'.$file->extension();
                // Save thumbnail image
                $img = Image::make($file->getRealPath());

                $img->resize(100, 100, function($constraint){

                    $constraint->aspectRatio();

                })->save(public_path('/college_images/thumb/').$imageName);

                //Save original size image
                $file->move(public_path('college_images'), $imageName);

                CollegeImage::insert([
                    'college_id' => $colleges->college_id,
                    'image_name' => $imageName
                ]);

                if($key == 0){
                    College::where('college_id','=',$colleges->college_id)->update([
                        'college_image' => $imageName,
                    ]);
                }
            }
        }

        $goals = $request->goal_id;

        if($goals)
        {
            foreach($goals as $key=>$goal){
                CollegeGoalWeightage::insert([
                    'college_id' => $colleges->college_id,
                    'goal_id' => $goal,
                    'weightage' => !empty($request->weightage) ? ($request->weightage[$key]) : NULL,
                ]);
            }
        }

        $courses = $request->course_id;
        if($courses){
            foreach($courses as $course){
                $values = explode(',',$course);
                CollegeCourse::insert([
                    'college_id' => $colleges->college_id,
                    'course_id'  => $values[0],
                ]);
            }
        }

        if(!empty($request->popular_major_name) && !empty($request->required_percentage)){
            foreach($request->popular_major_name as $key => $value){
                PopularMajor::insert([
                    'college_id' => $colleges->college_id,
                    'popular_major_name' => $request->popular_major_name[$key],
                    'required_percentage' => $request->required_percentage[$key],
                    'created_at' => date("Y-m-d H:i:s"),
                ]);
            }
        }

        return redirect()->route('colleges.index')->with('success','Record Successfully Inserted.');
    }

    public function edit($id)
    {
        $countries = Country::get();
        $colleges = College::find($id);
        $collegeImages = CollegeImage::where('college_id',$id)->get();
        $collegeCourses = CollegeCourse::where('college_id',$id)->get();
        $courses = Course::get();
        $goals = Goal::get();
        $collegeGoalWeightages = CollegeGoalWeightage::where('college_id',$id)->get();

        $popularMajors = PopularMajor::select('popular_majors.*','colleges.college_id')
        ->leftJoin('colleges','colleges.college_id','=','popular_majors.college_id')
        ->where('colleges.college_id',$id)
        ->get();

        $get_course_id = [];
        foreach($collegeCourses as $collegeCourse){
            $get_course_id[] = $collegeCourse->course_id;
        }

        return view('Admin.College.edit',compact('colleges','countries','collegeImages','get_course_id','courses','goals','collegeGoalWeightages','popularMajors'));
    }

    public function update(Request $request,$id)
    {
        $validate = $request->validate([
            'college_name' => 'required',
            'tuition_fee' => 'required',
            'application_deadline' => 'required',
            'scholarship_points' => 'required',
            'sat_min_range' => [
                                    'nullable', // The field can be null
                                    'numeric', // Ensures the value is a number
                                    'required_with:sat_max_range', // Required if sat_max_range is present
                                ],
            'sat_max_range' => [
                                    'nullable', // The field can be null
                                    'numeric', // Ensures the value is a number
                                    'required_with:sat_min_range', // Required if sat_max_range is present
                                ],
            'act_min_range' => [
                                    'nullable', // The field can be null
                                    'numeric', // Ensures the value is a number
                                    'required_with:act_max_range', // Required if sat_max_range is present
                                ],
            'act_max_range' => [
                                    'nullable', // The field can be null
                                    'numeric', // Ensures the value is a number
                                    'required_with:act_min_range', // Required if sat_max_range is present
                                ],
            // 'high_school_gpa' => 'numeric',
            // 'median_salary' => 'numeric',
            // 'avarage_debt' => 'numeric',
            // 'graduation_rate' => 'numeric',
            // 'acceptance_rate' => 'numeric',
        ], [
            'sat_min_range.required_with' => 'The SAT Min Range is required when SAT Max Range is provided.',
            'sat_max_range.required_with' => 'The SAT Max Range is required when SAT Min Range is provided.',
            'sat_min_range.numeric' => 'The SAT Min Range must be a number.',
            'sat_max_range.numeric' => 'The SAT Max Range must be a number.',
            'act_min_range.required_with' => 'The ACT Min Range is required when ACT Max Range is provided.',
            'act_max_range.required_with' => 'The ACT Max Range is required when ACT Min Range is provided.',
            'act_min_range.numeric' => 'The ACT Min Range must be a number.',
            'act_max_range.numeric' => 'The ACT Max Range must be a number.',
        ]);

        $colleges = College::find($id);

        if($request->hasFile('collegeImage'))
        {
            $files = $request->file('collegeImage');

            foreach($files as $key => $file){

                $imageName = rand().time().'.'.$file->extension();

                // Save thumbnail image
                $img = Image::make($file->getRealPath());

                $img->resize(100, 100, function($constraint){

                $constraint->aspectRatio();

                })->save(public_path('/college_images/thumb/').$imageName);

                //Save original size image
                $file->move(public_path('college_images'),$imageName);

                DB::table('college_images')->insert([
                    'college_id' => $id,
                    'image_name' => $imageName
                ]);
            }
        }

        $request['application_deadline'] = date("Y-m-d", strtotime($request['application_deadline']));

        $colleges->update($request->all());

        $goals = $request->goal_id;
        CollegeGoalWeightage::where('college_id', $id)->delete();
        if($goals)
        {
            foreach($goals as $key=>$goal){
                CollegeGoalWeightage::insert([
                    'college_id' => $colleges->college_id,
                    'goal_id' => $goal,
                    'weightage' => !empty($request->weightage) && isset($request->weightage[$key]) ? ($request->weightage[$key]) : NULL,
                    'created_at' => date("Y-m-d H:i:s"),
                ]);
            }
        }

        CollegeCourse::where('college_id', $id)->delete();

        if($request->course_id){
            foreach($request->course_id as $course){
                $values = explode(',',$course);

                CollegeCourse::insert([
                    'college_id' => $id,
                    'course_id' => $values[0],
                ]);
            }
        }

        PopularMajor::where('college_id', $id)->delete();
        if(!empty($request->popular_major_name) && !empty($request->required_percentage)){
            foreach($request->popular_major_name as $key => $value){
                PopularMajor::insert([
                    'college_id' => $id,
                    'popular_major_name' => $request->popular_major_name[$key],
                    'required_percentage' => $request->required_percentage[$key],
                    'created_at' => date("Y-m-d H:i:s"),
                ]);
            }
        }

        return redirect()->route('colleges.index')->with('success','Record Updated Successfully.');
    }

    public function destroy($id)
    {
        $data = College::find($id)->delete();

        return redirect()->route('colleges.index')->with('success','Record Deleted Successfully');
    }

    public function delete_img(Request $request)
    {
        $collegeImageId = $request->collegeImageId;
        // $collegeImageName = $request->collegeImageName;

        CollegeImage::where('college_image_id',$collegeImageId)->delete();

        // File::delete(public_path('/college_images/thumb/'.$collegeImageName));
        // File::delete(public_path('/college_images/'.$collegeImageName));
    }
}